{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Config","newOutputWithCode"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Config","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[38,4,39,4],[3,2,3,4],[32,10,33,10],[26,10,27,10],[20,9,25,9],[26,9,27,9],[20,10,25,10],[2,2,2,4],[2,8,2,10],[6,2,7,3],[5,9,6,9],[5,10,6,10]]}
[]
[]
[null,null,"Value driver tree tool",null,null,null,null,null,"Configuration options"]
[null,null,"A simple tool to generate Powerpoint or Excel VDTs from spreadsheet data"]
[null,null,null,null,null,null,null,null,"Value driver tree configuration"]
[null,null,"Step 1. Enter input data",null,null,null,null,null,"Value driver tree title:","Value driver tree","Nominate title to display above VDT on generated Excel and Powerpoint outputs"]
[null,null,"Generate an input template worksheet\nwith pre-populated dummy data"]
[null,null,null,null,null,null,null,null,"Display mathematical operators:","Yes","Select Yes to show best guess of math relationships"]
[null,null,null,null,null,null,null,null,"Display legend:","Yes","Select Yes to show scenario legend under VDT"]
[null,null,"Replace the pre-populated dummy data in-line with the following guidelines:",null,null,null,null,null,"Tree display type:","Compact","Select Compact to compress white space"]
[null,null,"A - Far left columns contain driver names, indented to show structure",null,null,null,null,null,"Combine scenarios with same value:","No","Select Yes to show single value for unchanged drivers"]
[null,null,"B - Following column shows the units to measure each driver",null,null,null,null,null,"Generate a calcs sheet:","No","Select Yes to generate output sheet with interim calcs"]
[null,null,"C - Following column shows scope of the tree to display in the outputs"]
[null,null,"       - Enter 'Root' in the row you want the tree to start",null,null,null,null,null,"Additional Excel VDT configuration"]
[null,null,"       - Enter 'Trim' in any rows at which you want to hide any further detail",null,null,null,null,null,"Output sheet name:","Output","Nominate title generated worksheet"]
[null,null,"D - Following columns each contain the values for one scenario",null,null,null,null,null,"Node box width: (in cells)",10,"Increase when driver names are too long to display"]
[null,null,"E - A single title row identifies columns for 'Unit', 'Scope', and each scenario",null,null,null,null,null,"Proportion of node width used for values:",0.3,"Increase when output is distorted by long values"]
[null,null,"F - The row beneath the title row contains the first row of VDT data"]
[null,null,"G - The row following the end of the VDT data is blank",null,null,null,null,null,"Additional PowerPoint VDT configuration"]
[null,null,null,null,null,null,null,null,"Slide template selection"]
[null,null,null,null,null,null,null,null,"Template location:","Default","Select any existing Powerpoint document or Powerpoint template, to use this theme. Alternatively, leave blank or set to 'Default' to output results on the default template"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Slide layout:","Blank","Nominate a slide layout, or leave blank or set to 'Default' to output results on a blank slide"]
[]
[]
[null,null,null,null,null,null,null,null,"Content positioning"]
[null,null,null,null,null,null,null,null,"Top margin: (in pixels)",40,"Adjust the top margin to leave room for a slide title"]
[null,null,null,null,null,null,null,null,"Bottom margin: (in pixels)",40,"Adjust the bottom margin to leave room for a footer"]
[null,null,null,null,null,null,null,null,"Left margin: (in pixels)",40,"Adjust left and right margins to horizontally position generated content on slide"]
[null,null,"Step 2. Locate data",null,null,null,null,null,"Right margin: (in pixels)",40]
[null,null,"Input worksheet name:",null,"Input"]
[null,null,"Title row:",null,2,null,null,null,"Additional slide formatting"]
[null,null,null,null,null,null,null,null,"Font size:",12,"Reduce when output is distorted by excess wrapping"]
[null,null,"Step 3. Choose scenarios",null,null,null,null,null,"Theme colour:",1,"Select colour from Powerpoint template theme"]
[null,null,"Scenarios to display: (semi-colon separated)",null,"Baseline; Target",null,null,null,"Mathematical operator type:","Round","Change to 'Offset' if distortion-free resizing required"]
[null,null,"Set to 'None' to generate tree with no values",null,null,null,null,null,"Proportion of driver node used for values:",0.35,"Increase when output is distorted by long values"]
[]
[null,null,"Step 4: Generate value driver trees"]

{"sheet":"newOutputWithCode","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}